06. 练习：POSITION、STRPOS 和 SUBSTR - AME DATA AS QUIZ 1

练习：POSITION 和 STRPOS

对于以下练习，需要用到 LEFT 和 RIGHT 以及 POSITION 或 STRPOS 知识。

  1. 使用 accounts 表格创建一个 名字 和 姓氏 列，用于存储 primary_poc 的名字和姓氏。

  2. 现在创建一个包含 sales_rep 表格中每个销售代表姓名的列，同样，需要提供名字和姓氏列。

Workspace

This section contains either a workspace (it can be a Jupyter Notebook workspace or an online code editor work space, etc.) and it cannot be automatically downloaded to be generated here. Please access the classroom with your account and manually download the workspace to your local machine. Note that for some courses, Udacity upload the workspace files onto https://github.com/udacity , so you may be able to download them there.

Workspace Information:

  • Default file path:
  • Workspace type: sql-evaluator
  • Opened files (when workspace is loaded): n/a

Next Concept